/**
 * 
 */
package mdb.com.vn.model;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;


/**
 * @author tu.dod
 *
 */
@Entity
@Table(name="IFTB_LUCKY_DRAW")
@NamedQueries({
	@NamedQuery(name = "LuckyDraw.findByRef", query = "SELECT c FROM LuckyDraw c WHERE c.transRef = :transRef ORDER BY c.id"),
	@NamedQuery(name = "LuckyDraw.findByTypeAndRef", query = "SELECT c FROM LuckyDraw c WHERE c.transRef = :transRef and c.ldrType = :ldrType ORDER BY c.id"),
	@NamedQuery(name = "LuckyDraw.countAllLuckyDraw", query = "SELECT count(c) FROM LuckyDraw c"),
	@NamedQuery(name = "LuckyDraw.findByStatus", query = "SELECT c FROM LuckyDraw c WHERE c.status = :status")
})
public class LuckyDraw extends AuditPojo implements Serializable{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO, generator = "GSEQ_LDR")
	@SequenceGenerator(name = "GSEQ_LDR", sequenceName = "SEQ_LDR")
	private long id;

	@Column(name="LDR_DESRIPTION")
	private String ldrDesription;

	@Column(name="STATUS")
	private int status;

	@Column(name="TRANS_REF")
	private String transRef;
	
	@Column(name="TRANS_REF1")
	private String transRef1;
	
	@Column(name="CUSTOMER_REF")
	private String customerRef;
	
	@Column(name="LDR_TYPE")
	private int ldrType;
	

	public long getId() {
		return id;
	}

	public void setId(long id) {
		this.id = id;
	}

	public String getLdrDesription() {
		return ldrDesription;
	}

	public void setLdrDesription(String ldrDesription) {
		this.ldrDesription = ldrDesription;
	}

	public int getStatus() {
		return status;
	}

	public void setStatus(int status) {
		this.status = status;
	}

	public String getTransRef() {
		return transRef;
	}

	public void setTransRef(String transRef) {
		this.transRef = transRef;
	}

	public String getCustomerRef() {
		return customerRef;
	}

	public void setCustomerRef(String customerRef) {
		this.customerRef = customerRef;
	}

	public int getLdrType() {
		return ldrType;
	}

	public void setLdrType(int ldrType) {
		this.ldrType = ldrType;
	}

	public String getTransRef1() {
		return transRef1;
	}

	public void setTransRef1(String transRef1) {
		this.transRef1 = transRef1;
	}


}
